'''
程序工程：从excel导入数据，并筛选出需要的列，以列表的形式存储

1、pandas数据导入
    导入excel数据
    数据清理
2、pandas 数据筛选
'''

import pandas as pd
import matplotlib.pyplot as plt

# 数据的导入和清理
ProblemList = pd.read_excel("D:\\5.大众品牌周报\\输出材料\\问题管理数据 模板.xlsx")
ProblemList.drop(["前端-探岳-黄灯","前端-探岳-绿灯","前端-Coupe-黄灯","前端-Coupe-绿灯",\
                  "后端-探岳-黄灯","后端-探岳-绿灯","后端-Coupe-黄灯","后端-Coupe-绿灯",\
                  "车门-探岳-黄灯","车门-探岳-绿灯","车门-Coupe-黄灯","车门-Coupe-绿灯",\
                  "内饰-探岳-黄灯","内饰-探岳-绿灯","内饰-Coupe-黄灯","内饰-Coupe-绿灯",\
                  "月份"],axis=1,inplace=True)
print(ProblemList)
print("****************************")


# 数据的选取
X = ProblemList['周序号']
Y_Yellow = ProblemList['黄灯']
Y_Green = ProblemList['绿灯']
Y_Jiejuelv = ProblemList['解决率']

print(X)
print(Y_Yellow)
print(Y_Green)

plt.plot(X,Y_Yellow)
plt.plot(X,Y_Green)
plt.plot(X,Y_Jiejuelv)
plt.show()
